inherited FRelatorio_inscr_subst: TFRelatorio_inscr_subst
  Left = 252
  Top = 143
  Width = 865
  Height = 551
  Caption = 'ICMS Substituto por Estado'
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 16
  inherited Panel1: TPanel
    Width = 857
  end
  inherited Panel2: TPanel
    Width = 857
  end
  inherited GroupBox1: TGroupBox
    object Label3: TLabel
      Left = 9
      Top = 24
      Width = 17
      Height = 16
      Caption = 'UF'
    end
    object GroupBox3: TGroupBox
      Left = 9
      Top = 71
      Width = 276
      Height = 54
      Caption = '  Per'#237'odo  '
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 0
      object Label4: TLabel
        Left = 135
        Top = 17
        Width = 7
        Height = 16
        Caption = 'a'
      end
      object Label5: TLabel
        Left = 8
        Top = 17
        Width = 16
        Height = 16
        Caption = 'De'
      end
      object DTINI: TDateEdit
        Left = 29
        Top = 17
        Width = 100
        Height = 21
        Ctl3D = False
        NumGlyphs = 2
        ParentCtl3D = False
        TabOrder = 0
      end
      object DTFIM: TDateEdit
        Left = 152
        Top = 17
        Width = 100
        Height = 21
        Ctl3D = False
        NumGlyphs = 2
        ParentCtl3D = False
        TabOrder = 1
      end
    end
    object DBLCBLocal: TDBLookupComboBox
      Left = 9
      Top = 38
      Width = 64
      Height = 22
      Ctl3D = False
      KeyField = 'UF'
      ListField = 'UF'
      ListSource = DSuf
      ParentCtl3D = False
      TabOrder = 1
      OnKeyDown = DBLCBLocalKeyDown
    end
  end
  inherited RLReport: TRLReport
    Left = 8
    Top = 221
    DataSource = DSPesquisa
    object RLGroup1: TRLGroup
      Left = 38
      Top = 156
      Width = 718
      Height = 50
      DataFields = 'CLI_ESTADOCORRESP'
      object RLBand2: TRLBand
        Left = 0
        Top = 0
        Width = 718
        Height = 27
        AfterPrint = RLBand2AfterPrint
        BeforePrint = RLBand2BeforePrint
        object RLDBText3: TRLDBText
          Left = 8
          Top = 5
          Width = 42
          Height = 16
          Alignment = taCenter
          AutoSize = False
          DataField = 'NF_NUMERONF'
          DataSource = DSPesquisa
        end
        object RLDBText4: TRLDBText
          Left = 84
          Top = 5
          Width = 42
          Height = 16
          Alignment = taCenter
          AutoSize = False
          DataField = 'NF_SERIENF'
          DataSource = DSPesquisa
        end
        object RLDBText5: TRLDBText
          Left = 168
          Top = 5
          Width = 94
          Height = 16
          Alignment = taCenter
          AutoSize = False
          DataField = 'NF_DATAEMISSAO'
          DataSource = DSPesquisa
        end
        object RLDBText6: TRLDBText
          Left = 316
          Top = 5
          Width = 30
          Height = 16
          Alignment = taCenter
          AutoSize = False
          DataField = 'CLI_ESTADOCORRESP'
          DataSource = DSPesquisa
        end
        object RLLabel9: TRLLabel
          Left = 631
          Top = 5
          Width = 20
          Height = 16
          Alignment = taCenter
          Caption = 'Sit'
        end
        object RLLabel12: TRLLabel
          Left = 449
          Top = 3
          Width = 36
          Height = 16
          Alignment = taRightJustify
          Caption = 'Total:'
        end
        object RLLabel13: TRLLabel
          Left = 559
          Top = 3
          Width = 36
          Height = 16
          Alignment = taRightJustify
          Caption = 'Total:'
        end
      end
      object RLBand3: TRLBand
        Left = 0
        Top = 27
        Width = 718
        Height = 22
        BandType = btSummary
        Borders.Sides = sdCustom
        Borders.DrawLeft = False
        Borders.DrawTop = False
        Borders.DrawRight = False
        Borders.DrawBottom = True
        AfterPrint = RLBand3AfterPrint
        object RLLabel2: TRLLabel
          Left = 460
          Top = 3
          Width = 25
          Height = 16
          Alignment = taRightJustify
          Caption = 'UF:'
        end
        object RLLabel3: TRLLabel
          Left = 361
          Top = 3
          Width = 36
          Height = 16
          Alignment = taRightJustify
          Caption = 'Total:'
        end
        object RLLabel17: TRLLabel
          Left = 569
          Top = 4
          Width = 25
          Height = 16
          Alignment = taRightJustify
          Caption = 'UF:'
        end
      end
    end
    object RLBand4: TRLBand
      Left = 38
      Top = 120
      Width = 718
      Height = 36
      BandType = btTitle
      object RLLabel1: TRLLabel
        Left = 387
        Top = 4
        Width = 98
        Height = 16
        Caption = 'Vr. ICMS Subs.'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel4: TRLLabel
        Left = 15
        Top = 4
        Width = 29
        Height = 16
        Caption = 'NFe'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel5: TRLLabel
        Left = 85
        Top = 4
        Width = 38
        Height = 16
        Caption = 'S'#233'rie'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel6: TRLLabel
        Left = 171
        Top = 4
        Width = 89
        Height = 16
        Caption = 'Data Emiss'#227'o'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel7: TRLLabel
        Left = 320
        Top = 4
        Width = 21
        Height = 16
        Caption = 'UF'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel8: TRLLabel
        Left = 608
        Top = 4
        Width = 60
        Height = 16
        Caption = 'Situa'#231#227'o'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel14: TRLLabel
        Left = 497
        Top = 4
        Width = 98
        Height = 16
        Caption = 'Vr. ICMS Subs.'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel15: TRLLabel
        Left = 432
        Top = 19
        Width = 53
        Height = 16
        Caption = 'Entrada'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel16: TRLLabel
        Left = 554
        Top = 19
        Width = 41
        Height = 16
        Caption = 'Saida'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
    end
    object RLBand5: TRLBand
      Left = 38
      Top = 206
      Width = 718
      Height = 29
      BandType = btSummary
      object RLLabel10: TRLLabel
        Left = 357
        Top = 10
        Width = 40
        Height = 16
        Alignment = taRightJustify
        Caption = 'Total:'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel11: TRLLabel
        Left = 460
        Top = 10
        Width = 25
        Height = 16
        Alignment = taRightJustify
        Caption = 'UF:'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RLLabel18: TRLLabel
        Left = 570
        Top = 9
        Width = 25
        Height = 16
        Alignment = taRightJustify
        Caption = 'UF:'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
    end
  end
  inherited QPesquisa: TQuery
    SQL.Strings = (
      'select'
      'notafiscalvenda.nf_numeronf,'
      'notafiscalvenda.nf_serienf,'
      'notafiscalvenda.nf_dataemissao,'
      'cliente.cli_estadocorresp,'
      'notafiscalvenda.nf_valoricmssub,'
      'notafiscalvenda.nf_situacao,'
      'cfop.cfop_naturezaoperacao'
      'from notafiscalvenda'
      
        'inner join cliente on (cliente.cli_codigo = notafiscalvenda.nf_c' +
        'liente)'
      
        'inner join cfop on (cfop.cfop_codigo = notafiscalvenda.nf_cfopnf' +
        ')'
      
        'where ((notafiscalvenda.excluido is null)or(notafiscalvenda.excl' +
        'uido = '#39'N'#39'))and'
      
        '     (notafiscalvenda.nf_situacao <> '#39'0'#39') and (notafiscalvenda.n' +
        'f_valoricmssub > 0)'
      'group by'
      'cliente.cli_estadocorresp,'
      'notafiscalvenda.nf_numeronf,'
      'notafiscalvenda.nf_serienf,'
      'notafiscalvenda.nf_dataemissao,'
      'notafiscalvenda.nf_valoricmssub,'
      'notafiscalvenda.nf_situacao,'
      'cfop.cfop_naturezaoperacao')
    Left = 320
    Top = 113
    object QPesquisaNF_NUMERONF: TIntegerField
      FieldName = 'NF_NUMERONF'
    end
    object QPesquisaNF_SERIENF: TStringField
      FieldName = 'NF_SERIENF'
      Size = 3
    end
    object QPesquisaNF_DATAEMISSAO: TDateTimeField
      FieldName = 'NF_DATAEMISSAO'
    end
    object QPesquisaCLI_ESTADOCORRESP: TStringField
      FieldName = 'CLI_ESTADOCORRESP'
      Size = 2
    end
    object QPesquisaNF_VALORICMSSUB: TFloatField
      FieldName = 'NF_VALORICMSSUB'
    end
    object QPesquisaNF_SITUACAO: TIntegerField
      FieldName = 'NF_SITUACAO'
    end
    object QPesquisaCFOP_NATUREZAOPERACAO: TStringField
      FieldName = 'CFOP_NATUREZAOPERACAO'
      Size = 7
    end
  end
  inherited DSPesquisa: TDataSource
    DataSet = CDSPesquisa
    Left = 448
    Top = 158
  end
  object Quf: TQuery
    Active = True
    DatabaseName = 'base'
    SQL.Strings = (
      'select * from UF')
    Left = 376
    Top = 137
  end
  object DSuf: TDataSource
    DataSet = Quf
    Left = 224
    Top = 214
  end
  object CDSPesquisa: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider1'
    Left = 472
    Top = 88
  end
  object DataSetProvider1: TDataSetProvider
    DataSet = QPesquisa
    Left = 568
    Top = 120
  end
end
